package com.hqyj.javaSpringBoot.modules.account.dao;

import com.hqyj.javaSpringBoot.modules.account.entity.UserRole;
import org.apache.ibatis.annotations.*;
import org.springframework.stereotype.Repository;

@Mapper
@Repository
public interface UserRoleDao {

    @Insert("insert into account_user_role (role_id,user_id) " +
            " values (#{roleId},#{userId})")
    @Options(useGeneratedKeys = true,keyProperty = "id",keyColumn = "id")
    void insertUserRole(UserRole userRole);

    @Delete("delete from account_user_role " +
            " where user_id=#{userId}")
    void deleteUserRoleByUserId(int userId);


    @Delete("delete from account_user_role " +
            " where role_id=#{roleId}")
    void deleteUserRoleByRoleId(int roleId);
}
